/*
 Navicat Premium Data Transfer

 Source Server         : sql server
 Source Server Type    : SQL Server
 Source Server Version : 16001135 (16.00.1135)
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001135 (16.00.1135)
 File Encoding         : 65001

 Date: 06/12/2024 21:51:45
*/


-- ----------------------------
-- Table structure for 登录信息表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[登录信息表]') AND type IN ('U'))
	DROP TABLE [dbo].[登录信息表]
GO

CREATE TABLE [dbo].[登录信息表] (
  [username] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [password] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [userrole] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [realname] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[登录信息表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 登录信息表
-- ----------------------------
INSERT INTO [dbo].[登录信息表] ([username], [password], [userrole], [realname]) VALUES (N'111@qq.com', N'pbkdf2_sha256$390000$exghFQZeshJ0mzHI20hV83$eOf764zyjDjTa7TQmiaGqzs3wmqSvfKKakkrUufSqa4=', N'8', NULL)
GO

INSERT INTO [dbo].[登录信息表] ([username], [password], [userrole], [realname]) VALUES (N'1873056302@qq.com', N'pbkdf2_sha256$390000$EaWWZ1yfRZNcJwhfAQw8Wu$mAPLF0d9g4QEISRYcXXZCF4+8QCH5RB8TIM/tY+t+p0=', N'2', NULL)
GO

INSERT INTO [dbo].[登录信息表] ([username], [password], [userrole], [realname]) VALUES (N'873056302@qq.com', N'pbkdf2_sha256$390000$YqUFbh8cguxCtjMpIu9A8p$Kkxz0fX5bDU1Iv5bOSFeAnmFQ31++0r7u7Jv9amE4Zw=', NULL, NULL)
GO

INSERT INTO [dbo].[登录信息表] ([username], [password], [userrole], [realname]) VALUES (N'ruichen.sima@bjfu.edu.cn', N'pbkdf2_sha256$390000$hxcJOA5j3aappUEwAiXVU0$5XLIS9lUFjK1+0lcC87J/O+QkeYasH+ZHNxOq6lrvoE=', N'2', NULL)
GO

INSERT INTO [dbo].[登录信息表] ([username], [password], [userrole], [realname]) VALUES (N'zhangsan@qq.com', N'pbkdf2_sha256$390000$5W0aKl7wTEpCWSMi4RyR8b$9tHVJUvaIO6u6T0+WA1egnsrDEuQE/q9VYLMeCZK//0=', N'考生', NULL)
GO


-- ----------------------------
-- Primary Key structure for table 登录信息表
-- ----------------------------
ALTER TABLE [dbo].[登录信息表] ADD CONSTRAINT [PK_登录信息表] PRIMARY KEY CLUSTERED ([username])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

